<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
	<title>Tableau Desktop | ElasticSearch 7.7 权威指南中文版</title>
	<meta name="keywords" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <meta name="description" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <!-- Give IE8 a fighting chance -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
	<link rel="stylesheet" type="text/css" href="../static/styles.css" />
	<script>
	var _link = 'sql-client-apps-tableau.html';
    </script>
</head>
<body>
<div class="main-container">
    <section id="content">
        <div class="content-wrapper">
            <section id="guide" lang="zh_cn">
                <div class="container">
                    <div class="row">
                        <div class="col-xs-12 col-sm-8 col-md-8 guide-section">
                            <div style="color:gray; word-break: break-all; font-size:12px;">原英文版地址: <a href="https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-client-apps-tableau.html" rel="nofollow" target="_blank">https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-client-apps-tableau.html</a>, 原文档版权归 www.elastic.co 所有<br/>本地英文版地址: <a href="../en/sql-client-apps-tableau.html" rel="nofollow" target="_blank">../en/sql-client-apps-tableau.html</a></div>
                        <!-- start body -->
                  <div class="page_header">
<strong>重要</strong>: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 <a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/index.html" rel="nofollow">当前版本文档</a>。
</div>
<div id="content">
<div class="breadcrumbs">
<span class="breadcrumb-link"><a href="index.html">Elasticsearch Guide [7.7]</a></span>
»
<span class="breadcrumb-link"><a href="xpack-sql.html">SQL access</a></span>
»
<span class="breadcrumb-link"><a href="sql-client-apps.html">SQL Client Applications</a></span>
»
<span class="breadcrumb-node">Tableau Desktop</span>
</div>
<div class="navheader">
<span class="prev">
<a href="sql-client-apps-workbench.html">« SQL Workbench/J</a>
</span>
<span class="next">
<a href="sql-spec.html">SQL Language »</a>
</span>
</div>
<div class="section xpack">
<div class="titlepage"><div><div>
<h2 class="title">
<a id="sql-client-apps-tableau"></a>Tableau Desktop<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/tableau.asciidoc">edit</a><a class="xpack_tag" href="https://www.elastic.co/subscriptions"></a>
</h2>
</div></div></div>
<p>You can use the Elasticsearch ODBC driver to access Elasticsearch data from Tableau Desktop.</p>
<div class="important admon">
<div class="icon"></div>
<div class="admon_content">
<p>Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this product, please reach out to its vendor.</p>
</div>
</div>
<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_prerequisites_10"></a>Prerequisites<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/tableau.asciidoc">edit</a>
</h3>
</div></div></div>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a href="https://www.tableau.com/products/desktop" class="ulink" target="_top">Tableau Desktop</a> 2018 or higher
</li>
<li class="listitem">
Elasticsearch SQL <a class="xref" href="sql-odbc.html" title="SQL ODBC">ODBC driver</a>
</li>
<li class="listitem">
A preconfigured User or System DSN (see <a class="xref" href="sql-odbc-setup.html#dsn-configuration" title="2. Configure a DSN">Configuration</a> section on how to configure a DSN).
</li>
</ul>
</div>
</div>

<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_data_loading_4"></a>Data loading<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/tableau.asciidoc">edit</a>
</h3>
</div></div></div>
<p>First, you’ll need to choose ODBC as the source to load data from. Once launched, click on the <em>More…​</em> menu item and in the expanded
list of connectors, choose <em>Other Databases (ODBC)</em>:</p>
<p><a id="apps_tableau_fromodbc"></a><strong>ODBC as data source</strong><span class="image"><img src="../static/images/sql/odbc/apps_tableau_fromodbc.png" alt="apps tableau fromodbc"></span></p>
<p>In the new connection window that appears, select the previously configured DSN that will connect to the desired Elasticsearch instance. Press the
<em>Connect</em> button. In case credentials are needed, a new windows - driver’s DSN editor - will be launched and you’ll need to provide the
<em>Username</em> and <em>Password</em> in the respective fields. (Note that these will not be stored as part of the DSN, but only remembered for the
duration of the session).
If the connection is successful, the <em>Connection Attributes</em> section of the connection window is populated with the respective details;
press the <em>Sign In</em> button next:</p>
<p><a id="apps_tableau_connd"></a><strong>Authenticate and sign in</strong><span class="image"><img src="../static/images/sql/odbc/apps_tableau_connd.png" alt="apps tableau connd"></span></p>
<p>In Tableau Desktop’s main window then choose the name of Elasticsearch instance as the <em>Database</em>, select one table that you’d like to load from
the list (click on the magnifying glass icon to have them all shown), drag the table over the work area, then click the <em>Update Now</em>
button to load a preview of the table:</p>
<p><a id="apps_tableau_loaded"></a><strong>Data loaded</strong><span class="image"><img src="../static/images/sql/odbc/apps_tableau_loaded.png" alt="apps tableau loaded"></span></p>
</div>

</div>
<div class="navfooter">
<span class="prev">
<a href="sql-client-apps-workbench.html">« SQL Workbench/J</a>
</span>
<span class="next">
<a href="sql-spec.html">SQL Language »</a>
</span>
</div>
</div>

                  <!-- end body -->
                        </div>
                        <div class="col-xs-12 col-sm-4 col-md-4" id="right_col">
                        
                        </div>
                    </div>
                </div>
            </section>
        </div>
    </section>
</div>
<script src="../static/cn.js"></script>
</body>
</html>